Re: Looking for postgres equivalent of mysqlimport

Поиск
Список
Период
Сортировка
От M. Bastin
Тема Re: Looking for postgres equivalent of mysqlimport
Дата
Msg-id a06110412bd70bd647413@[192.168.0.243]
обсуждение исходный текст
Ответ на Re: Looking for postgres equivalent of mysqlimport  (Sean Davis <sdavis2@mail.nih.gov>)
Ответы Re: Looking for postgres equivalent of mysqlimport  (Sean Davis <sdavis2@mail.nih.gov>)
Список pgsql-novice
At 9:37 AM -0400 9/17/04, Sean Davis wrote:
>Marc,
>
>Thanks.  That is what I had thought.  Another detail--I have fields
>(including some dates) that include "" (empty fields).  What is the
>best way to deal with those?  Should I just convert them to NULL
>(assuming that was the actual meaning) and then use that as the NULL
>string in the copy command?

Sean,

I think you could try that.  You may leave them empty as well (after
stripping '"') and use that for NULL with the COPY command.

Marc

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Installation problem...
Следующее
От: Sean Davis
Дата:
Сообщение: Re: Looking for postgres equivalent of mysqlimport